home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload Trio 2
/
Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO
/
dir30
/
tabpr212.zip
/
TABPRO.HLP
< prev
next >
Wrap
Text File
|
1993-11-26
|
9KB
|
253 lines
\OVERVIEW
\ACCEPT
\ACCEPT_1
┌─────────────────────┐
│ Tab123 Professional │
└─────────────────────┘
TabPro pastes Lotus 123, Symphony and Excel Worksheet data into
AutoCAD drawings as either text entities or an AutoCAD block. TabPro
reads Lotus 123 files through release 4, and also Microsoft Excel
XLS files through Excel version 4.0 (BIFF level 4).
■ TabPro imports the data values and formatting; column width,
cell alignment, and numeric formatting.
■ TabPro reads the worksheet files in their native format, there
is NO need to export to an ASCII file.
■ TabPro provides the user full control of scale and spacing
parameters, layer settings, text style, as well as grid and
border weight and linetypes.
■ TabPro can create a link to the source file and range where
changes in the spreadsheet can automatically update the table
in AutoCAD.
■ TabPro includes an API to provide AutoLISP and ADS programmers
access to spreadsheet data, and to create tables under program
control.
\ABOUT
Tab123 Professional
Mountain Software
1579 Nottingham Road
Charleston, WV 25314
Phone 304-346-9585
FAX 304-744-1785
Compuserve 70717,3564
Internet 70717.3564@compuserve.com
\FILENAME
■ Filename
Enter the filename of a Lotus 123 or Excel file, or select the
File Button to invoke the file dialog box. Tab123 supports Lotus
123 and Symphony formats thru release 4 as well as all versions
of Excel XLS files.
\RANGE
■ Range
Enter the range to import or select the Range button to pick a
Names range from the worksheet file. The range must be in the form
<sheet>:<column><row>..<sheet>:<column><row>. The <sheet> specifier
is only necessary if you wish to extract data from a sheet other
that sheet "A" in a Lotus 123 WK3 file.
Examples:
A1..E25 column A row 1 to column E row 25
B:C11..B:G34 sheet B column A row 1 to column E row 25
* all cells (a blank range also selects all)
MY_RANGE named range
\TEXT_LAYER
■ Text Layer
Select the AutoCAD layer on which to place text entities or select
the Layers button to invoke the AutoCAD "DDLMODES" dialog box where
you can create a new layer or modify layer settings. If you make
a diffrent layer current while in the DDLMODES dialog, that layer
then becomes the text layer.
\STYLE
■ Style Creation Dialogue
Select a text style to create either from the pick list or the icon
menu. You may page through the styles by selecting the <Next> and
<Previous> buttons. Once a style is selected the style parameters
must be specified to completely define the text style. Any existing
text style of the same name will be overwritten.
> Height: Text height in drawing units
> Width Factor: Width multiplier
> Obliquing Angle: Text slant angle
> Backwards: Mirror text in X plane
> Upside down Mirror text in Y plane
> Vertical Draw text vertical
\TEXT_STYLE
■ Text Style
Select the AutoCAD text style (font) to use for text entities,
or select the Styles button to create a new text style.
\TEXT_HEIGHT
■ Text Height
Enter the text height in drawing units. The default value is taken
from the current style if the style contains a text height, or from
the AutoCAD system variable TEXTSIZE. The entire table is scaled
based in this value.
\ROW_SCALE
■ Row Scale Factor
The row scale factor defines the spacing between rows in terms
of the text height. This factor is multiplied by the text height
to determine the row spacing. A value of 1.0 is will allow
adjacent text rows to just touch bottom to top. The default value
is 2.0.
\COLUMN_OFFSET
■ Column Offset Factor
The column offset factor defines the horizontal spacing (in
characters) between the start or end of the text and the cell
boundry. The default value is 1.00.
\GRID
■ Grid
Select the grid button to select grid linetype and border line
weight. You can also adjust the density of linetypes using
AutoCAD's LTSCALE system variable.
■ Grid Layer
Select the AutoCAD layer on which to place grid line entities, or
select the Layers button to invoke the AutoCAD "DDLMODES" dialog
box where you can create a new layer or modify layer settings.
\DDSTYLE
■ DDSTYLE Command
TabPro adds the DDSTYLE command. This command provides a style
creation dialog box interface to duplicate the STYLE command.
See help index item "STYLE".
\API
■ TabPro API
The TabPro Applications Program Interface creates two functions
for use by AutoLISP and ADS programmers.
(C:TABPRO <file> <range> <point>)
Use: a dual use function that either creates a table from a
spreadsheet file and range, or returns the spreadsheet data
as an AutoLISP list.
Parameters:
file <str> the worksheet filename (eg C:\EXCEL\TABLE.XLS)
range <str> the named range or range specification (eg A1..D10)
point <point> the insertion point for the upper left corner if the
table if the point paramter is not present the data
will be returned in the form of an AutoLISP list in
row / column order of dotted pairs. Each dotted pair
will contain the cell address and formatted cell
contents.
Example:
(("A1" . "Planes") ("B2" . "Boats") ("A2" . "123") ("B2" . "23"))
(C:TABPRO_UPDATE <mode>)
Use: Updates table links to external spradsheet files using the
file, range, and other parameters contained in the block's
attributes. This function is used to automatically update
tables when a drawing is loaded. You can place the function
in the file ACAD.LSP file within the S::STARTUP function
to execute after a drawing loads. ACAD.LSP might contain
the following:
(xload "TABPRO") ; load TabPro
(defun S::STARTUP()
(C:TABPRO_UPDATE)
)
Parameters:
mode <int> - 0 or nil conditional update, if the spreadsheet
file has changed then the table will be
updated.
1 update all tables unconditionally
\TABLE_MODE
■ Table Mode
You may create a table in either of two different forms.
Text and Lines
The table will be created using LINEs for the grid, a POLYLINE
for the border, and TEXT entities in each cell. This format
provides for adjustments of the table layout using the commands
STRETCH, MOVE, etc. Cell contents can be edited using the DDEDIT
command.
Block and Attributes
An anonomous block and a block insert entity with attributes is
created in the drawing. Each cell is a visible attribute within
the block insert, and table specifications are
saved as invisable attributes. The cell data and table specs
can be edited using the command DDATTE If the spreadsheet range
or any of the other specs are changed, then the new specs will
apply when the table is updated from disk. Any changes to the
cell values will be lost when the table is updated.
Tables created in block mode can be automatically updated from
the spreadsheet when the drawing is opened by adding the
C:TABPRO_UPDATE function to the S::STARTUP function in your
ACAD.LSP file. They can also be updated by clicking the
"Update" button.
\UPDATE
■ Table Update
The table update button updates all block mode tables in the
drawing. Block mode tables are linked to the spreadsheet file
and range with invisible attributes. You can also use the command
TABPRO_UPDATE or the function (C:TABPRO_UPDATE) to update tables.
\COMMANDS
■ Commands defined by TabPro
TABPRO - Displays the TabPro Dialogue
TABPRO11 - Runs TabPro in command line mode.
TABPRO_UPDATE - Conditionally updates block mode tables
TABPRO_PASSWORD - Register TabPro with your name and password.